7/30/2017

Real Estate Market 2017

  • 2017 real estate market in New York area

  • New York vs. Long Island

  • Number of sold properties by 2017-07-26: 28909

  • Number of new listing properties by 2017-07-26: 28909

Realtor.com

Home Page of Realtor.com


Web Scrapping In Listing Page Using Scrapy

Total listing number and pages


Web Scrapping In Listing Page Using Scrapy

Pagination at the bottom


1.1 Number of sold properties by Month

1.2 Number of sold properties by Type

1.3 Number of sold properties by County

## 1.4 Number of sold properties by County ~ Type

2.1 Median price change by county in 2017

2.2 Median price change by day in 2017

2.3 Median price change by type in 2017

3.1 sfh_floorsize ~ price

3.2 sfh_lotsize ~ price

3.3 sfh_floor/lot_size ~ price

### 3.4 county/floorsize ~ sale price

3.5 type/floorsize ~ sale price——————————————————– NEW

4.1 top_median_sale_price by city

4.2 Number of sold properties by zipcode in long island

5.1 Find the correlation between variables

5.2 scatter plot to find the correlation

## Warning: package 'car' was built under R version 3.4.1

5.3 distribution of sold price based on county

5.4 modeling using floorsize

## `geom_smooth()` using method = 'gam'